Skip to main content

What’s New

Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
NodeJS Deprecation
AWS has announced that it is deprecating NodeJS 12, 14, and 16. To avoid any issues as a result of this deprecation, upgrade your instances of the Qrvey platform as described in this announcement.
Learn More
Version: 8.5

Multiseries Bar Chart

Multiseries Bar Charts are used when you want to present a single value in more than one category. Effectively, a Multiseries chart consists of two dimensions and a measure. Users need to add a single Category, Value and Series field to create something similar to a pivot chart. For example, if you want to show total sales by country and slice it by quarter, then you need to add country as Category, total order as Value, and order date as Series. The value of each Category is represented by the size of the respective bar and each value in the Series is represented by a color that can be distinguished by adding a legend to the chart.

Multiseries Bar Charts serve for visual comparison of aggregated values in your data throughout the series field.

ms-bar-chart

Creating a Multiseries Bar Chart​

To create a Multiseries Bar Chart, drag and drop a data field from the Data Panel onto either the corresponding shelf or the canvas.

In the case below, we want to show the order quantities in different statuses of shipments per country of the order. We drag and drop country as Category, Quantity as Values, and status as Series. We continue styling the chart in the Configuration Panel until getting the visualization we want.

ms-bar-chart

If you have only one category you’d like to visualize, you can use a Bar Chart.

Styling the Multiseries Bar Chart​

In the Configuration Panel on the right of the Chart Builder, you can style different aspects of your chart.

General​

The General section is available for all chart types, and the options vary depending on the chart selected. For more information on the options, see General Chart Settings.

Note: Use the Table Calculations option to add calculations to your chart. For more information, see Table Calculations.

Styles​

The Styles section enables you to control various visual elements of the charts, such as colors, labels, and more. It is available for most chart types, and the options vary depending on the chart selected. For a glossary of all styles, see Styles. Style options specific to this chart are listed below.

  • Theme. Set one of the predetermined themes for a more unified look of your charts.
    • Match colors across charts. Select to Unify the colors of each categorical value throughout the page and application.
  • Axis Labels - Show or hide the labels of the axes.
  • Category axis (normally the X-axis)
    • Label - give the axis a custom label.
    • Values - show or hide values on the axis.
    • Values Rotation - if values are enabled, decide how you want them to be displayed.
  • Values axis (typically y axis)
    • Label - give the axis a custom label.
    • Values - show or hide values on the axis.
    • Values Rotation - if value labels are enabled, decide how you want them to be displayed. You can use this option to avoid overlapping labels.
    • Format - set the format of the values choosing between Default, Abbreviated, Decimal (set the number of decimal points), Currency (choose the currency from the drop-down menu and set the number of decimal points), Percentage (set the number of decimal points), Scientific. Values can also be formatted from the Values column pill.
    • Scale Type - the default scale type is Linear; however, a linear scale is not appropriate for data that is spread over a wide range. Use the Logarithmic scale to display numerical data over a wide range of values in a compact way.
    • Min Range - set the minimum value for the axis.
    • Max Range - set the maximum value for the axis.
    • Steps - Depending on how wide the axis range is, the default configuration could display a lot of tick marks, making it hard to read or analyze the chart. Intervals are set to Auto by default, meaning the chart will calculate the appropriate intervals based on the axis scale range and the dataset values. In the example below, the range of data is from 0 to 8,000. So when we set the step to 1000 units, we get 8 tick marks and when set to 10,000, only 1 tick mark is displayed. ms-bar-chart It’s important to keep in mind that when the axis range is vast (e.g., 0 - 10,000,000), setting the “Steps” option to 1 will create 10 million tick marks, causing performance issues on the chart and probably blocking the browser. To avoid this situation, the chart will ignore the defined value and fall back to automatic mode.
  • Bar Width % - bar width is set to Auto by default, meaning the system adjusts the percentage to what it sees as most adequate considering the size of the chart. If the width is set to 100%, the bars use up all of the chart’s space and there’s no gap left between them. Choose a width percentage other than 0 to decide the width of each bar and the gap between them. Setting the percentage to 0 will return the mode to automatic.
  • Type - choose if you want your columns to appear stacked (all Series values in the same column), cluster (Series values are represented by individual bars side by side), or 100% (bars going all the way to the top of the Y-axis, representing each Series as the percentage of the total, rather than value).
  • Offset. Determines the offset of the chart. Select whether to configure a manual offset as a Percentage or in Pixels, and enter the desired values in the Left and Top/Bottom fields. To enable the platform to automatically manage the offsets, click Reset to Default to set the values under Left and Top/Bottom to Auto. ms-bar-chart

Sorting​

Like all Multiseries Charts, you can sort by either the category or aggregated values from the column pills. If the column is not included in the chart, go to the Sorting section of the Configuration Panel and pick your desired column from the dropdown, and select the sorting direction.

For more information, see Sorting.

Layers​

Add a Trend Line or a Reference Line to your chart to allow users to visually compare the data against some set trend or reference value.

Format​

The Small Multiples feature is available in all XY Charts. You can apply Conditional Formatting to your Multiseries Chart.

Filters​

You can also add Filters to your data by expanding the Filters section in the configuration panel or by clicking on the Filters button in the toolbar above the canvas. Filters that are created in the Chart Builder are hidden from End Users. These types of filters can’t be edited or interacted with in the view mode. For more information, see Filters.

For more on Multiseries Charts, watch the Multiseries Chart video